Google Links
Follow the links below to find material targeted to the unit's elements, performance criteria, required skills and knowledge
Required Skills
analytical skills to determine the elements of the SQL statement
understand the client requirements
learning skills to research encountered problems independently
literacy skills to create an SQL statement using syntax
planning and organisational skills to write an SQL statement that is crossbrowser compatible
problemsolving skills to translate the required outcomes from the database into SQL statements
integrate SQL statements into a variety of serverside languages
combining condition and Boolean operators
Evidence Required
Range Statement
Database may include: | AccessInformixMicrosoft Structured Query Language (MS SQL)MySQLOraclePostgreSybase. |
SQL statements may include: | aggregate functionsconditions and Boolean operatorsconditional operatorsmathematical operatorstable joins. |
Manipulating data may include: | creating tables and rowsdeleting tables and rowsadding and altering dataretrieving data. |